global root_dir = "`1'"

include "$root_dir/code/config/config.do"

cap noi log using ${log_dir}/table_5_baseline.log, replace name(tabl)

capture noi {

    * Table_baseline 

    qui do ${code_dir}/config/tabletools.do

    use ${final_dir}/regression_dataset_from1970_tfacit1.dta, clear
    tab year, gen(YY_)

    estimates clear
    foreach yy in 1995 {
        *the usual cloning and renaming for better readability inside this file
        clonevar LSW = lswMPm_`yy'_a
        clonevar HSW = hswMPm_`yy'_a
        clonevar VAEMP = vaempMPm_`yy'_a
        clonevar GDPGAP = lngdpgap_`yy'_a
        clonevar GDPPC = gdppcMPm_`yy'_a
        clonevar stockown = k${depvar}_${ttt} 
        clonevar stockownzero = k${depvar}_${ttt}0  
        clonevar stockother = kNOT_${depvar}_${ttt} 
        clonevar stockotherzero = kNOT_${depvar}_${ttt}0
        clonevar spilloversown = spill${depvar}${ttt}_`yy'_a
        clonevar spilloversother = spillN${depvar}${ttt}_`yy'_a
        clonevar spilloversownzero = spill${depvar}${ttt}_`yy'_a0
        clonevar spilloversotherzero = spillN${depvar}${ttt}_`yy'_a0
        bys lse_id : egen _total_${depvar}_${ttt}_`yy' = sum(${depvar}_${ttt}) if year>=`yy'+2 & year <= 2009+2
        bys lse_id : egen total_${depvar}_${ttt}_`yy' = max(_total_${depvar}_${ttt}_`yy')
        drop _total_${depvar}_${ttt}_`yy'
        egen yearctry = group(year country_shr_1995) if year <= 2009
        egen yearctryindustry = group(year industry country_shr_1995) if year <= 2009
        egen yearindustry = group(year industry) if year <= 2009
        sort lse_id year

        * 1) GDPGAP | F+IY
        ppmlhdfe F2.${depvar}_${ttt} LSW HSW GDPGAP stockown stockownzero stockother stockotherzero spilloversown spilloversownzero spilloversother spilloversotherzero if year>=`yy' & missing_weights_`yy'==0 & missing_spill_weights_`yy' == 0 & maxweight_`yy' < 1 & total_${depvar}_${ttt}_`yy'>0, absorb(lse_id yearindustry) vce(cluster lse_id)
        estadd local f "\yes"
        estadd local iy "\yes"
        estadd local cy "\no"
        estadd local obs "{\num{`e(N)'}}"
        estadd local firms "{\num{`e(N_clust)'}}"
        estimates store col`yy'_1
        * 2) GDPGAP + VAEMP | F+IY
        ppmlhdfe F2.${depvar}_${ttt} LSW HSW GDPGAP VAEMP stockown stockownzero stockother stockotherzero spilloversown spilloversownzero spilloversother spilloversotherzero if year>=`yy' & missing_weights_`yy'==0 & missing_spill_weights_`yy' == 0 & maxweight_`yy' < 1 & total_${depvar}_${ttt}_`yy'>0, absorb(lse_id yearindustry) vce(cluster lse_id)
        estadd local f "\yes"
        estadd local iy "\yes"
        estadd local cy "\no"
        estadd local obs "{\num{`e(N)'}}"
        estadd local firms "{\num{`e(N_clust)'}}"
        estimates store col`yy'_2
        * 3) GDPGAP + GDPPC | F+IY
        ppmlhdfe F2.${depvar}_${ttt} LSW HSW GDPGAP GDPPC stockown stockownzero stockother stockotherzero spilloversown spilloversownzero spilloversother spilloversotherzero if year>=`yy' & missing_weights_`yy'==0 & missing_spill_weights_`yy' == 0 & maxweight_`yy' < 1 & total_${depvar}_${ttt}_`yy'>0, absorb(lse_id yearindustry) vce(cluster lse_id)
        estadd local f "\yes"
        estadd local iy "\yes"
        estadd local cy "\no"
        estadd local obs "{\num{`e(N)'}}"
        estadd local firms "{\num{`e(N_clust)'}}"
        estimates store col`yy'_3
        * 4) GDPGAP | F+IY+CY
        ppmlhdfe F2.${depvar}_${ttt} LSW HSW GDPGAP stockown stockownzero stockother stockotherzero spilloversown spilloversownzero spilloversother spilloversotherzero if year>=`yy' & missing_weights_`yy'==0 & missing_spill_weights_`yy' == 0 & maxweight_`yy' < 1 & total_${depvar}_${ttt}_`yy'>0,absorb(lse_id yearindustry yearctry) vce(cluster lse_id)
        estadd local f "\yes"
        estadd local iy "\yes"
        estadd local cy "\yes"
        estadd local obs "{\num{`e(N)'}}"
        estadd local firms "{\num{`e(N_clust)'}}"
        estimates store col`yy'_4
        * 5) GDPGAP + VAEMP | F+IY+CY
        ppmlhdfe F2.${depvar}_${ttt} LSW HSW GDPGAP VAEMP stockown stockownzero stockother stockotherzero spilloversown spilloversownzero spilloversother spilloversotherzero if year>=`yy' & missing_weights_`yy'==0 & missing_spill_weights_`yy' == 0 & maxweight_`yy' < 1 & total_${depvar}_${ttt}_`yy'>0,absorb(lse_id yearindustry yearctry) vce(cluster lse_id)
        estadd local f "\yes"
        estadd local iy "\yes"
        estadd local cy "\yes"
        estadd local obs "{\num{`e(N)'}}"
        estadd local firms "{\num{`e(N_clust)'}}"
        estimates store col`yy'_5
        * 6) GDPGAP + GDPPC | F+IY+CY
        ppmlhdfe F2.${depvar}_${ttt} LSW HSW GDPGAP GDPPC stockown stockownzero stockother stockotherzero spilloversown spilloversownzero spilloversother spilloversotherzero if year>=`yy' & missing_weights_`yy'==0 & missing_spill_weights_`yy' == 0 & maxweight_`yy' < 1 & total_${depvar}_${ttt}_`yy'>0,absorb(lse_id yearindustry yearctry) vce(cluster lse_id)
        estadd local f "\yes"
        estadd local iy "\yes"
        estadd local cy "\yes"
        estadd local obs "{\num{`e(N)'}}"
        estadd local firms "{\num{`e(N_clust)'}}"
        estimates store col`yy'_6

        clonevar GDPPC_foreign = gdppcMPm_shr4_foreign_`yy'_a	
        clonevar VAEMP_foreign = vaempMPm_shr4_foreign_`yy'_a
        clonevar GDPgap_foreign = lngdpgap_shr_foreign_`yy'_a
        clonevar LSW_foreign = lswMPm_shr4_foreign_`yy'_a
        clonevar HSW_foreign = hswMPm_shr4_foreign_`yy'_a

        * 7) GDPGAP | F+IY+CY | foreign
        ppmlhdfe F2.${depvar}_${ttt} LSW_foreign HSW_foreign GDPgap_foreign stockown stockownzero stockother stockotherzero spilloversown spilloversownzero spilloversother spilloversotherzero if year>=`yy' & missing_weights_`yy'==0 & missing_spill_weights_`yy' == 0 & maxweight_`yy' < 1 & total_${depvar}_${ttt}_1995>0,absorb(lse_id yearindustry yearctry) vce(cluster lse_id)
        estadd local f "\yes"
        estadd local iy "\yes"
        estadd local cy "\yes"
        estadd local obs "{\num{`e(N)'}}"
        estadd local firms "{\num{`e(N_clust)'}}"
        estimates store col`yy'_7
        * 8) GDPGAP + VAEMP | F+IY+CY | foreign
        ppmlhdfe F2.${depvar}_${ttt} LSW_foreign HSW_foreign GDPgap_foreign VAEMP_foreign stockown stockownzero stockother stockotherzero spilloversown spilloversownzero spilloversother spilloversotherzero if year>=`yy' & missing_weights_`yy'==0 & missing_spill_weights_`yy' == 0 & maxweight_`yy' < 1 & total_${depvar}_${ttt}_`yy'>0,absorb(lse_id yearindustry yearctry) vce(cluster lse_id)
        estadd local f "\yes"
        estadd local iy "\yes"
        estadd local cy "\yes"
        estadd local obs "{\num{`e(N)'}}"
        estadd local firms "{\num{`e(N_clust)'}}"
        estimates store col`yy'_8
        * 9) GDPGAP + GDPPC | F+IY+CY | foreign
        ppmlhdfe F2.${depvar}_${ttt} LSW_foreign HSW_foreign GDPgap_foreign GDPPC_foreign stockown stockownzero stockother stockotherzero spilloversown spilloversownzero spilloversother spilloversotherzero if year>=`yy' & missing_weights_`yy'==0 & missing_spill_weights_`yy' == 0 & maxweight_`yy' < 1 & total_${depvar}_${ttt}_`yy'>0,absorb(lse_id yearindustry yearctry) vce(cluster lse_id)
        estadd local f "\yes"
        estadd local iy "\yes"
        estadd local cy "\yes"
        estadd local obs "{\num{`e(N)'}}"
        estadd local firms "{\num{`e(N_clust)'}}"
        estimates store col`yy'_9
    }
    
    setlabels
    qui do ${code_dir}/config/tabletools.do

    dhoztab * using ${tab_dir}/main/Table_5_baseline.tex,  b(%10.2f) se(%10.2f) nogaps nomtitles numbers nolines nonotes replace  showdepvarinfo sfmt(a1) scalars("f \noalign{\medskip} Firm fixed effects" "iy Industry \stimes year fixed effects" "cy Country \stimes year fixed effects" "obs \noalign{\medskip} Observations"  "firms Number of firms") label mgroups("Domestic and foreign" "Foreign", pattern(1 0 0 0 0 0 1 0 0) span prefix(\multicolumn{@span}{c}{) suffix(}) erepeat(\cmidrule(lr){@span})) drop(*zero _cons) noobs rename(LSW_foreign LSW HSW_foreign HSW GDPgap_foreign GDPGAP VAEMP_foreign VAEMP GDPPC_foreign GDPPC) depvar("Auto95") order(LSW HSW GDPGAP VAEMP GDPPC stockown stockother spilloversown spilloversother) notes("This table presents the results of our baseline regression. The independent variables are lagged by two periods. Coefficients are estimated using conditional Poisson fixed effects regressions (HHG). All columns include firm and industry-year fixed effects. Columns 4--9 add country-year fixed effects. In Columns 7--9, the macroeconomic variables are the normalized foreign variables as defined in the text. Standard errors are clustered at the firm-level and reported in parentheses.")
 
    *vscode shows the } in the command as wrong, but it works
}
if _rc == 0 {
    display "Execution finished successfully."
}
else {
    display "Execution finished with errors."
}

cap log close tabl